package cn.net.shuxing.yifu.common.mapper;


import cn.net.shuxing.yifu.common.bean.UserDealHistory;
import cn.net.shuxing.yifu.common.bean.UserInfoBind;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.time.LocalDate;
import java.util.List;

public interface UserInfoBindMapper extends Mapper<UserInfoBind> {

    @Select("SELECT\n" +
            "*\n" +
            "FROM\n" +
            "\tuser_info_bind\n" +
            "WHERE\n" +
            "phone_num = #{hangSale} OR deal_type = #{hangBuy} OR deal_type = #{cansel} OR deal_type = #{buyBack} OR deal_type = #{fee})\n")
    public List<UserDealHistory> getHangBuyAndHangSaleAndSystemBuyBackByUserIdAndDate(@Param("userName") String userName);
}
